USE [NuevoConsultorioSQL]
GO

/****** Object:  Table [dbo].[nDatosPersonalClinica]    Script Date: 03/10/2009 20:46:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[nDatosPersonalClinica](
	[codPersona] [uniqueidentifier] NOT NULL,
	[codPersonaAnterior] [int]  NOT NULL,
	[Nombre] [nvarchar](30) NULL,
	[Apellido] [nvarchar](30) NULL,
	[Categoria] [nvarchar](15) NULL,
	[codTipoDoc] [int] NULL,
	[nroDoc] [nvarchar](20) NULL,
	[EstadoCivil] [nvarchar](10) NULL,
	[Sexo] [nvarchar](3) NULL,
	[Telefono] [nvarchar](15) NULL,
	[Celular] [nvarchar](15) NULL,
	[Email] [nvarchar](50) NULL,
	[fechaNac] [datetime] NULL,
	[Domicilio] [nvarchar](50) NULL,
	[Provincia] [nvarchar](30) NULL,
	[Localidad] [nvarchar](20) NULL,
	[CodigoPostal] [nvarchar](20) NULL,
	[InicioVac] [datetime] NULL,
	[finVac] [datetime] NULL)

GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('-') FOR [Nombre]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('-') FOR [Apellido]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('-') FOR [Categoria]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ((0)) FOR [codTipoDoc]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('-') FOR [nroDoc]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('-') FOR [EstadoCivil]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('-') FOR [Sexo]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('-') FOR [Telefono]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('-') FOR [Celular]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('-') FOR [Email]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('1/1/1900') FOR [fechaNac]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('-') FOR [Domicilio]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('-') FOR [Provincia]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('-') FOR [Localidad]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('-') FOR [CodigoPostal]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('1/1/2007') FOR [InicioVac]
GO

ALTER TABLE [dbo].[nDatosPersonalClinica] ADD  DEFAULT ('1/1/2007') FOR [finVac]
GO


